Tiny File Manager | customer_maintain

Back Back Up Advanced Editor

<?php
//======================================================================================
//
// Function: De- or Reactivate customer
//
// Programmer: AR
// Date      : 2025-06-03
//
// Copyright Reeft A/S (c) - 2025
//======================================================================================

//======================================================================================
// General config
//======================================================================================
	include "config/config.php";
	include "include/REEFT_date_convert.php";

//======================================================================================
// Get input
//======================================================================================
	if (isset($_REQUEST["mode"]))  			$mode 		= $_REQUEST["mode"];
	else $mode = '';

if (isset($_REQUEST["customerKey"])) {
		$customerKey = $_REQUEST["customerKey"];
	} else {
		$customerKey = '';
	}
	
	if ( $mode == '' ) {
		echo "There's no action....1";
		exit;
	}

if ( $mode <> '*deactivate' and $mode <> '*reactivate' ) {
		echo "There's no action....2";
		exit;
	}

if ( $customerKey == 'hovsa' ) {
		echo "There's no customer key....";
		exit;
	}

//======================================================================================
// Get session variables
//======================================================================================
	include "include/getsession.php";

//======================================================================================
// Set language
//======================================================================================
	include "include/set_language.php";
	
//======================================================================================
// Set header
//======================================================================================
	header('Content-Type: application/json;charset=utf-8');

//======================================================================================
// Init fields
//======================================================================================

$returnCode  		= '00';
	$returnMsg   		= 'Alles ist gut';
	$entries_found 		= 1;
	$sql 				= '';

$currentDate 		= date('Y-m-d');
	$currentTime 		= date('H:i:s');

//======================================================================================
// Set database
//======================================================================================

$db_name = $CUSTOMER_DATABASE_PATH;
	//$db_name = 'customer/REEFT_integration.sqlite3';
	
//======================================================================================
// Start me up...
//======================================================================================
	$startTime = microtime(true);

//======================================================================================
// Check if database file exists
//======================================================================================
	if (!file_exists($db_name)) {
		die(json_encode(['error' => "Database file '$db_name' does not exist."]));
	}

//======================================================================================
// Connect to some DB
//======================================================================================

$DFT_SQLLITE_IP	= $db_name;
	include "include/db_connect.php";

//======================================================================================
// Set active, token and other default values
//======================================================================================

$timestamp	= REEFT_current_utc();

//======================================================================================
// Check typeCode
//======================================================================================

//======================================================================================
// Create SQL
//======================================================================================
	
	if ( $mode == '*deactivate') {
		
		$sql = "UPDATE reeft_customer SET cust_active = 0 WHERE pk_customer = '$customerKey'";
	}
	if ( $mode == '*reactivate') {
		
		$sql = "UPDATE reeft_customer SET cust_active = 1 WHERE pk_customer = '$customerKey'";
	}

//echo $sql;

//======================================================================================
// Get data
//======================================================================================
	include "include/db_run_sql.php";

//======================================================================================
// Paint it black
//======================================================================================
	
//======================================================================================
// Create header
//======================================================================================

// Create header
	$aryHeader = array();
	$aryHeader["mode"] 			= $mode;
	$aryHeader["returnCode"] 	= $returnCode;
	$aryHeader["returnMsg"] 	= $returnMsg;
	$aryHeader["entries_found"] = $entries_found;
	$aryHeader["currentDate"] 	= $currentDate;
	$aryHeader["currentTime"] 	= $currentTime;

// Create array and prepare for json encoding
	$returnJson["header"] = $aryHeader;